Spread Silverlight Documentation
Evaluate(Object[]) Method


The args contains 2 - 255 items: average_range, criteria_range1,criteria1, [criteria_range2], [criteria2], ..

Average_range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.

Criteria_range1, criteria_range2, ... are 1 to 127 ranges in which to evaluate the associated criteria.

Criteria1, criteria2, ... are 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged.

Returns the average (arithmetic mean) of all cells that meet multiple criteria.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object
'Usage
 
Dim instance As CalcAverageIfsFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)
public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 2 - 255 items: average_range, criteria_range1,criteria1, [criteria_range2], [criteria2], ..

Average_range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.

Criteria_range1, criteria_range2, ... are 1 to 127 ranges in which to evaluate the associated criteria.

Criteria1, criteria2, ... are 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged.

Return Value

A System.Object value that indicates the evaluate result.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

CalcAverageIfsFunction Class
CalcAverageIfsFunction Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.